Table 3–9: Server performance parameters
|
Syntax
|
Parameter
|
Purpose
|
|
|
After-image File Management Archive Directory List
|
Specify the directories where the AI File Management utility writes the archived after-image files.
|
|
|
After-image File Management Archive Directory Create
|
Direct the AI File Management utility to create the specified directories.
|
|
|
After-image File Management Archive Interval
|
Specify on-demand mode archiving or the extent switch interval for timed-mode archiving.
|
|
|
After-image buffers
|
Specify the number of after-image buffers when running AIW.
|
|
|
After-image stall
|
Suspend database activity when an empty after-image (AI) file is unavailable.
|
|
|
Blocks in database buffers
|
Specify the number of blocks in the database buffers.
|
|
|
Maximum private buffers per connection
|
Control the number of private buffers a connection can request through the Private Read-only Buffers (-Bp) parameter.
|
|
|
Before-image buffers
|
Specify the number of before-image buffers when running BIW.
|
|
|
Threshold stall
|
Send a message to the log file when the recovery log threshold is reached. Use with -bithold.
|
|
|
Recovery log threshold
|
Specify the maximum size of the recovery log files.
|
|
|
Cluster Mode
|
Startup a cluster-enabled database.
|
|
|
Direct I/O (UNIX, Windows only)
|
Open all files in unbuffered mode.
|
|
|
Before-image cluster age
|
Specify the number of seconds before OpenEdge reuses a before-image cluster.
|
|
|
Group delay
|
Specifies the number of milliseconds a transaction waits before committing.
|
|
|
Hash table entries
|
Specify the number of hash table entries for the buffer pool.
|
|
|
No crash protection
|
Run OpenEdge without using database integrity or recovery.
|
|
|
Lock table entries
|
Specify the number of entries in the record locking table.
|
|
|
Maximum JTA Transactions
|
Control the number of JTA transactions simultaneously allowed.
|
|
|
Delayed BI file write (UNIX, Windows only)
|
Delay writing the last before-image (BI) file records.
|
|
|
Message buffer size
|
Specify the message buffer size for network client/server protocols.
|
|
|
VLM page table entry optimization (digital UNIX only)
|
Allocate shared memory in multiples of 8MB for VLM64 support.
|
|
|
Shared-memory overflow size (UNIX, Windows only)
|
Replace the default value of the shared-memory overflow area.
|
|
|
Number of users
|
Specify the maximum number of users connected to the database.
|
|
|
Pending Connection Time
|
Specify the amount of time a client has to connect to a server before the broker clears the client’s reservation.
|
|
|
Pin shared memory
|
Prevent the database engine from swapping shared memory contents to disk.
|
|
|
Semaphore sets (UNIX only)
|
Change the number of semaphore sets available to a broker.
|
|
|
Spin lock retries (UNIX, Windows only)
|
Specify the number of times a process tries to acquire a latch before pausing.
|
|
|
SQL Open Cursors
|
Specify the maximum number of cursors open at any one time.
|
|
|
SQL stack size
|
Specify the size, in MB, of the SQL Stack.
|
|
|
SQL statement cache size
|
Specify the number of statements allowed in the SQL statement cache.
|
|
|
SQL Sorting Memory
|
Defines the size of the temporary table buffer in memory.
|
|
|
SQL Sorting on Disk
|
Defines the size of the temporary table for backup storage.
|
|
|
SQL Temp Table Data Page
|
Defines the size of the temporary table data page.
|